Database Query dialog box enables you to set Data Base and Query Type for a query.
Select a Data Base file from the site physical resources tree in the Site Manager.
Select Query Type from the pull-down menu.
Database Query can be one of the following types:
Delete. Deletes one or more records from a
Database.
Insert. Adds a new record to a specified field of
a database.
Select Selects and displays records from a
specified database.
Update Updates records in a database.
After you have selected a Data Source and Query Type, click the Edit Query button to access the Query Properties dialog box and edit your query.